from app import db


class MemberComments(db.Model):
    __tablename__ = 'member_comments'

    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer, nullable=False, index=True)
    food_id = db.Column(db.String(200), nullable=False, index=True)
    pay_order_id = db.Column(db.Integer, nullable=False, index=True)
    score = db.Column(db.Integer, nullable=False)
    content = db.Column(db.String(200))
    created_time = db.Column(db.DateTime, nullable=False)